How to: Update data in a PivotTable.

Solution:

Select any cell in the PivotTable and select 'Refresh Data' from the 'Data' menu.